Dataset statistics
| Number of variables | 25 |
|---|---|
| Number of observations | 213775 |
| Missing cells | 1313523 |
| Missing cells (%) | 24.6% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 163.9 MiB |
| Average record size in memory | 803.7 B |
Variable types
| Numeric | 9 |
|---|---|
| Categorical | 15 |
| Boolean | 1 |
AIRPORT_ID has a high cardinality: 2465 distinct values | High cardinality |
LOCATION has a high cardinality: 512 distinct values | High cardinality |
OPID has a high cardinality: 585 distinct values | High cardinality |
RUNWAY has a high cardinality: 808 distinct values | High cardinality |
STATE has a high cardinality: 63 distinct values | High cardinality |
TIME has a high cardinality: 1468 distinct values | High cardinality |
df_index is highly correlated with INCIDENT_YEAR | High correlation |
DISTANCE is highly correlated with HEIGHT and 1 other fields | High correlation |
HEIGHT is highly correlated with DISTANCE and 1 other fields | High correlation |
INCIDENT_YEAR is highly correlated with df_index | High correlation |
SPEED is highly correlated with DISTANCE and 1 other fields | High correlation |
df_index is highly correlated with INCIDENT_YEAR | High correlation |
DISTANCE is highly correlated with HEIGHT and 1 other fields | High correlation |
HEIGHT is highly correlated with DISTANCE and 1 other fields | High correlation |
INCIDENT_YEAR is highly correlated with df_index | High correlation |
SPEED is highly correlated with DISTANCE and 1 other fields | High correlation |
df_index is highly correlated with INCIDENT_YEAR | High correlation |
DISTANCE is highly correlated with HEIGHT | High correlation |
HEIGHT is highly correlated with DISTANCE and 1 other fields | High correlation |
INCIDENT_YEAR is highly correlated with df_index | High correlation |
SPEED is highly correlated with HEIGHT | High correlation |
AC_CLASS is highly correlated with ENROUTE_STATE | High correlation |
INDICATED_DAMAGE is highly correlated with ENROUTE_STATE | High correlation |
PRECIPITATION is highly correlated with ENROUTE_STATE | High correlation |
FAAREGION is highly correlated with STATE | High correlation |
PHASE_OF_FLIGHT is highly correlated with ENROUTE_STATE | High correlation |
TIME_OF_DAY is highly correlated with ENROUTE_STATE | High correlation |
SKY is highly correlated with ENROUTE_STATE | High correlation |
STATE is highly correlated with FAAREGION | High correlation |
ENROUTE_STATE is highly correlated with AC_CLASS and 6 other fields | High correlation |
AC_MASS is highly correlated with ENROUTE_STATE | High correlation |
df_index is highly correlated with ENROUTE_STATE and 1 other fields | High correlation |
DISTANCE is highly correlated with ENROUTE_STATE and 3 other fields | High correlation |
ENROUTE_STATE is highly correlated with df_index and 15 other fields | High correlation |
FAAREGION is highly correlated with ENROUTE_STATE and 4 other fields | High correlation |
HEIGHT is highly correlated with DISTANCE and 3 other fields | High correlation |
INCIDENT_MONTH is highly correlated with ENROUTE_STATE | High correlation |
INCIDENT_YEAR is highly correlated with df_index and 1 other fields | High correlation |
LATITUDE is highly correlated with ENROUTE_STATE and 4 other fields | High correlation |
LONGITUDE is highly correlated with ENROUTE_STATE and 4 other fields | High correlation |
PHASE_OF_FLIGHT is highly correlated with DISTANCE and 3 other fields | High correlation |
PRECIPITATION is highly correlated with SKY | High correlation |
SKY is highly correlated with PRECIPITATION | High correlation |
SPEED is highly correlated with DISTANCE and 4 other fields | High correlation |
STATE is highly correlated with ENROUTE_STATE and 4 other fields | High correlation |
TIME_OF_DAY is highly correlated with ENROUTE_STATE | High correlation |
WARNED is highly correlated with ENROUTE_STATE | High correlation |
AC_MASS is highly correlated with ENROUTE_STATE and 1 other fields | High correlation |
INDICATED_DAMAGE is highly correlated with ENROUTE_STATE | High correlation |
c_score is highly correlated with ENROUTE_STATE and 4 other fields | High correlation |
DISTANCE has 59548 (27.9%) missing values | Missing |
ENROUTE_STATE has 213769 (> 99.9%) missing values | Missing |
HEIGHT has 87483 (40.9%) missing values | Missing |
LOCATION has 213190 (99.7%) missing values | Missing |
PHASE_OF_FLIGHT has 65371 (30.6%) missing values | Missing |
PRECIPITATION has 103893 (48.6%) missing values | Missing |
RUNWAY has 30089 (14.1%) missing values | Missing |
SKY has 99952 (46.8%) missing values | Missing |
SPEED has 133030 (62.2%) missing values | Missing |
TIME has 98272 (46.0%) missing values | Missing |
TIME_OF_DAY has 78080 (36.5%) missing values | Missing |
AC_CLASS has 65249 (30.5%) missing values | Missing |
AC_MASS has 65597 (30.7%) missing values | Missing |
LOCATION is uniformly distributed | Uniform |
df_index has unique values | Unique |
DISTANCE has 137490 (64.3%) zeros | Zeros |
HEIGHT has 54541 (25.5%) zeros | Zeros |
Reproduction
| Analysis started | 2022-01-18 21:19:21.349045 |
|---|---|
| Analysis finished | 2022-01-18 21:20:16.260431 |
| Duration | 54.91 seconds |
| Software version | pandas-profiling v3.1.0 |
| Download configuration | config.json |
df_index
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONUNIQUE| Distinct | 213775 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 121333.1461 |
| Minimum | 0 |
|---|---|
| Maximum | 255908 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 11296.7 |
| Q1 | 61636.5 |
| median | 120496 |
| Q3 | 181928.5 |
| 95-th percentile | 231086.3 |
| Maximum | 255908 |
| Range | 255908 |
| Interquartile range (IQR) | 120292 |
Descriptive statistics
| Standard deviation | 70272.93468 |
|---|---|
| Coefficient of variation (CV) | 0.5791734322 |
| Kurtosis | -1.18210924 |
| Mean | 121333.1461 |
| Median Absolute Deviation (MAD) | 60173 |
| Skewness | 0.006462416908 |
| Sum | 2.593799331 × 1010 |
| Variance | 4938285348 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 161263 | 1 | < 0.1% |
| 161168 | 1 | < 0.1% |
| 161170 | 1 | < 0.1% |
| 161171 | 1 | < 0.1% |
| 161172 | 1 | < 0.1% |
| 161173 | 1 | < 0.1% |
| 161174 | 1 | < 0.1% |
| 161176 | 1 | < 0.1% |
| 161177 | 1 | < 0.1% |
| Other values (213765) | 213765 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 | |
| 10 | 1 |
| Value | Count | Frequency (%) |
| 255908 | 1 | |
| 255907 | 1 | |
| 255906 | 1 | |
| 255840 | 1 | |
| 255758 | 1 | |
| 255756 | 1 | |
| 255755 | 1 | |
| 255754 | 1 | |
| 255421 | 1 | |
| 255417 | 1 |
| Distinct | 2465 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.4 MiB |
| KDEN | 7786 |
|---|---|
| KDFW | 6752 |
| KORD | 5371 |
| KJFK | 4418 |
| KMEM | 4152 |
| Other values (2460) |
Length
| Max length | 5 |
|---|---|
| Median length | 4 |
| Mean length | 3.996608584 |
| Min length | 3 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 837 ? |
|---|---|
| Unique (%) | 0.4% |
Sample
| 1st row | KMIE |
|---|---|
| 2nd row | KMSY |
| 3rd row | KORD |
| 4th row | KMHT |
| 5th row | KELP |
Common Values
| Value | Count | Frequency (%) |
| KDEN | 7786 | 3.6% |
| KDFW | 6752 | 3.2% |
| KORD | 5371 | 2.5% |
| KJFK | 4418 | 2.1% |
| KMEM | 4152 | 1.9% |
| KSMF | 3272 | 1.5% |
| KSLC | 3223 | 1.5% |
| KMCO | 3008 | 1.4% |
| KDTW | 2962 | 1.4% |
| KLGA | 2847 | 1.3% |
| Other values (2455) | 169984 |
Length
| Value | Count | Frequency (%) |
| kden | 7877 | 3.7% |
| kdfw | 6752 | 3.2% |
| kord | 5371 | 2.5% |
| kjfk | 4418 | 2.1% |
| kmem | 4152 | 1.9% |
| ksmf | 3272 | 1.5% |
| kslc | 3223 | 1.5% |
| kmco | 3008 | 1.4% |
| kdtw | 2962 | 1.4% |
| klga | 2847 | 1.3% |
| Other values (2454) | 169893 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
DISTANCE
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSINGZEROS| Distinct | 181 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 59548 |
| Missing (%) | 27.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.7795403204 |
| Minimum | 0 |
|---|---|
| Maximum | 99 |
| Zeros | 137490 |
| Zeros (%) | 64.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 5 |
| Maximum | 99 |
| Range | 99 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 3.532196689 |
|---|---|
| Coefficient of variation (CV) | 4.531127636 |
| Kurtosis | 90.67904576 |
| Mean | 0.7795403204 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 7.804500252 |
| Sum | 120226.165 |
| Variance | 12.47641345 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 137490 | |
| 1 | 2295 | 1.1% |
| 5 | 1931 | 0.9% |
| 3 | 1613 | 0.8% |
| 2 | 1584 | 0.7% |
| 10 | 1425 | 0.7% |
| 4 | 874 | 0.4% |
| 15 | 803 | 0.4% |
| 0.5 | 710 | 0.3% |
| 20 | 673 | 0.3% |
| Other values (171) | 4829 | 2.3% |
| (Missing) | 59548 |
| Value | Count | Frequency (%) |
| 0 | 137490 | |
| 0.01 | 2 | < 0.1% |
| 0.05 | 2 | < 0.1% |
| 0.1 | 73 | < 0.1% |
| 0.125 | 4 | < 0.1% |
| 0.13 | 11 | < 0.1% |
| 0.15 | 1 | < 0.1% |
| 0.16 | 1 | < 0.1% |
| 0.2 | 133 | 0.1% |
| 0.25 | 148 | 0.1% |
| Value | Count | Frequency (%) |
| 99 | 3 | < 0.1% |
| 95 | 1 | < 0.1% |
| 90 | 2 | < 0.1% |
| 80 | 3 | < 0.1% |
| 75 | 6 | < 0.1% |
| 65 | 2 | < 0.1% |
| 62 | 1 | < 0.1% |
| 60 | 15 | |
| 55 | 3 | < 0.1% |
| 52 | 1 | < 0.1% |
| Distinct | 5 |
|---|---|
| Distinct (%) | 83.3% |
| Missing | 213769 |
| Missing (%) | > 99.9% |
| Memory size | 6.5 MiB |
| RI | |
|---|---|
| NY | |
| GA | |
| NJ | |
| AB |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 4 ? |
|---|---|
| Unique (%) | 66.7% |
Sample
| 1st row | NY |
|---|---|
| 2nd row | GA |
| 3rd row | NJ |
| 4th row | RI |
| 5th row | RI |
Common Values
| Value | Count | Frequency (%) |
| RI | 2 | < 0.1% |
| NY | 1 | < 0.1% |
| GA | 1 | < 0.1% |
| NJ | 1 | < 0.1% |
| AB | 1 | < 0.1% |
| (Missing) | 213769 |
Length
Pie chart
| Value | Count | Frequency (%) |
| ri | 2 | |
| ny | 1 | |
| ga | 1 | |
| nj | 1 | |
| ab | 1 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.2 MiB |
| ASO | |
|---|---|
| AEA | |
| AGL | |
| ASW | |
| AWP | |
| Other values (5) |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | AGL |
|---|---|
| 2nd row | ASW |
| 3rd row | AGL |
| 4th row | ANE |
| 5th row | ASW |
Common Values
| Value | Count | Frequency (%) |
| ASO | 43702 | |
| AEA | 35181 | |
| AGL | 33589 | |
| ASW | 28227 | |
| AWP | 27224 | |
| ANM | 21979 | |
| ACE | 10216 | 4.8% |
| ANE | 7971 | 3.7% |
| FGN | 4409 | 2.1% |
| AAL | 1277 | 0.6% |
Length
Pie chart
| Value | Count | Frequency (%) |
| aso | 43702 | |
| aea | 35181 | |
| agl | 33589 | |
| asw | 28227 | |
| awp | 27224 | |
| anm | 21979 | |
| ace | 10216 | 4.8% |
| ane | 7971 | 3.7% |
| fgn | 4409 | 2.1% |
| aal | 1277 | 0.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
HEIGHT
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSINGZEROS| Distinct | 636 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 87483 |
| Missing (%) | 40.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 819.2182165 |
| Minimum | 0 |
|---|---|
| Maximum | 25000 |
| Zeros | 54541 |
| Zeros (%) | 25.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 30 |
| Q3 | 700 |
| 95-th percentile | 4500 |
| Maximum | 25000 |
| Range | 25000 |
| Interquartile range (IQR) | 700 |
Descriptive statistics
| Standard deviation | 1791.618142 |
|---|---|
| Coefficient of variation (CV) | 2.186985232 |
| Kurtosis | 17.16208504 |
| Mean | 819.2182165 |
| Median Absolute Deviation (MAD) | 30 |
| Skewness | 3.59538724 |
| Sum | 103460707 |
| Variance | 3209895.565 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 54541 | |
| 100 | 5781 | 2.7% |
| 50 | 5196 | 2.4% |
| 200 | 4414 | 2.1% |
| 500 | 4266 | 2.0% |
| 1000 | 3819 | 1.8% |
| 10 | 3379 | 1.6% |
| 300 | 3339 | 1.6% |
| 3000 | 2789 | 1.3% |
| 2000 | 2722 | 1.3% |
| Other values (626) | 36046 | |
| (Missing) | 87483 |
| Value | Count | Frequency (%) |
| 0 | 54541 | |
| 1 | 134 | 0.1% |
| 2 | 206 | 0.1% |
| 3 | 175 | 0.1% |
| 4 | 80 | < 0.1% |
| 5 | 1103 | 0.5% |
| 6 | 41 | < 0.1% |
| 7 | 44 | < 0.1% |
| 8 | 68 | < 0.1% |
| 9 | 20 | < 0.1% |
| Value | Count | Frequency (%) |
| 25000 | 3 | |
| 24300 | 1 | < 0.1% |
| 24000 | 1 | < 0.1% |
| 23000 | 1 | < 0.1% |
| 22000 | 1 | < 0.1% |
| 21300 | 1 | < 0.1% |
| 21000 | 4 | |
| 20000 | 7 | |
| 19000 | 1 | < 0.1% |
| 18500 | 2 | < 0.1% |
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.216727868 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 5 |
| median | 8 |
| Q3 | 9 |
| 95-th percentile | 11 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 2.781289303 |
|---|---|
| Coefficient of variation (CV) | 0.3853947875 |
| Kurtosis | -0.575629048 |
| Mean | 7.216727868 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -0.3823638586 |
| Sum | 1542756 |
| Variance | 7.735570187 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 8 | 31016 | |
| 7 | 28562 | |
| 9 | 28069 | |
| 10 | 25532 | |
| 5 | 19642 | |
| 6 | 18142 | |
| 11 | 14753 | |
| 4 | 14499 | |
| 3 | 10314 | 4.8% |
| 12 | 8936 | 4.2% |
| Other values (2) | 14310 |
| Value | Count | Frequency (%) |
| 1 | 7382 | 3.5% |
| 2 | 6928 | 3.2% |
| 3 | 10314 | 4.8% |
| 4 | 14499 | |
| 5 | 19642 | |
| 6 | 18142 | |
| 7 | 28562 | |
| 8 | 31016 | |
| 9 | 28069 | |
| 10 | 25532 |
| Value | Count | Frequency (%) |
| 12 | 8936 | 4.2% |
| 11 | 14753 | |
| 10 | 25532 | |
| 9 | 28069 | |
| 8 | 31016 | |
| 7 | 28562 | |
| 6 | 18142 | |
| 5 | 19642 | |
| 4 | 14499 | |
| 3 | 10314 | 4.8% |
| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2009.814132 |
| Minimum | 1990 |
|---|---|
| Maximum | 2020 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.6 MiB |
Quantile statistics
| Minimum | 1990 |
|---|---|
| 5-th percentile | 1994 |
| Q1 | 2005 |
| median | 2012 |
| Q3 | 2016 |
| 95-th percentile | 2019 |
| Maximum | 2020 |
| Range | 30 |
| Interquartile range (IQR) | 11 |
Descriptive statistics
| Standard deviation | 7.827250144 |
|---|---|
| Coefficient of variation (CV) | 0.003894514433 |
| Kurtosis | -0.4634070087 |
| Mean | 2009.814132 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | -0.6916566006 |
| Sum | 429648016 |
| Variance | 61.26584481 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2019 | 14643 | 6.8% |
| 2018 | 13966 | 6.5% |
| 2017 | 12767 | 6.0% |
| 2015 | 12045 | 5.6% |
| 2014 | 11950 | 5.6% |
| 2016 | 11758 | 5.5% |
| 2020 | 10263 | 4.8% |
| 2013 | 9950 | 4.7% |
| 2012 | 9755 | 4.6% |
| 2011 | 9213 | 4.3% |
| Other values (21) | 97465 |
| Value | Count | Frequency (%) |
| 1990 | 1702 | |
| 1991 | 2224 | |
| 1992 | 2437 | |
| 1993 | 2471 | |
| 1994 | 2501 | |
| 1995 | 2588 | |
| 1996 | 2742 | |
| 1997 | 3175 | |
| 1998 | 3551 | |
| 1999 | 4157 |
| Value | Count | Frequency (%) |
| 2020 | 10263 | |
| 2019 | 14643 | |
| 2018 | 13966 | |
| 2017 | 12767 | |
| 2016 | 11758 | |
| 2015 | 12045 | |
| 2014 | 11950 | |
| 2013 | 9950 | |
| 2012 | 9755 | |
| 2011 | 9213 |
| Distinct | 2458 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 36.90004351 |
| Minimum | -37.673333 |
|---|---|
| Maximum | 71.28545 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 267 |
| Negative (%) | 0.1% |
| Memory size | 1.6 MiB |
Quantile statistics
| Minimum | -37.673333 |
|---|---|
| 5-th percentile | 26.07258 |
| Q1 | 33.30783 |
| median | 38.81809 |
| Q3 | 40.8501 |
| 95-th percentile | 45.44906 |
| Maximum | 71.28545 |
| Range | 108.958783 |
| Interquartile range (IQR) | 7.54227 |
Descriptive statistics
| Standard deviation | 6.877066742 |
|---|---|
| Coefficient of variation (CV) | 0.1863701527 |
| Kurtosis | 10.71662481 |
| Mean | 36.90004351 |
| Median Absolute Deviation (MAD) | 3.425 |
| Skewness | -1.535535012 |
| Sum | 7888306.802 |
| Variance | 47.29404697 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 39.85841 | 7786 | 3.6% |
| 32.89595 | 6752 | 3.2% |
| 41.9796 | 5371 | 2.5% |
| 40.63975 | 4418 | 2.1% |
| 35.04242 | 4152 | 1.9% |
| 38.69542 | 3272 | 1.5% |
| 40.78839 | 3223 | 1.5% |
| 28.42889 | 3008 | 1.4% |
| 42.21206 | 2962 | 1.4% |
| 40.77724 | 2847 | 1.3% |
| Other values (2448) | 169984 |
| Value | Count | Frequency (%) |
| -37.673333 | 1 | < 0.1% |
| -37.008056 | 5 | < 0.1% |
| -34.838417 | 12 | < 0.1% |
| -34.822222 | 69 | |
| -34.559175 | 2 | < 0.1% |
| -33.964806 | 1 | < 0.1% |
| -33.946111 | 9 | < 0.1% |
| -33.392975 | 24 | < 0.1% |
| -29.99383333 | 2 | < 0.1% |
| -27.3833 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 71.28545 | 15 | |
| 70.325 | 6 | < 0.1% |
| 70.20995 | 1 | < 0.1% |
| 70.19476 | 10 | < 0.1% |
| 69.3711127 | 1 | < 0.1% |
| 66.88468 | 34 | |
| 66.82853 | 1 | < 0.1% |
| 66.60013 | 1 | < 0.1% |
| 65.7586111 | 1 | < 0.1% |
| 65.69756 | 1 | < 0.1% |
| Distinct | 512 |
|---|---|
| Distinct (%) | 87.5% |
| Missing | 213190 |
| Missing (%) | 99.7% |
| Memory size | 6.5 MiB |
| A | 12 |
|---|---|
| . | 4 |
| 10 MI E | 4 |
| 5 MI FINAL | 4 |
| 5 MILES OUT | 4 |
| Other values (507) |
Length
| Max length | 60 |
|---|---|
| Median length | 11 |
| Mean length | 11.01538462 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 474 ? |
|---|---|
| Unique (%) | 81.0% |
Sample
| 1st row | 20 NE BNA |
|---|---|
| 2nd row | 30 NM EAST OAK |
| 3rd row | 50 MI E MCI |
| 4th row | 25 MI NW SUX |
| 5th row | 30 NW MIA |
Common Values
| Value | Count | Frequency (%) |
| A | 12 | < 0.1% |
| . | 4 | < 0.1% |
| 10 MI E | 4 | < 0.1% |
| 5 MI FINAL | 4 | < 0.1% |
| 5 MILES OUT | 4 | < 0.1% |
| 3 MI FINAL | 4 | < 0.1% |
| 15 NW | 4 | < 0.1% |
| 5 MI W | 4 | < 0.1% |
| SBN-MEM | 4 | < 0.1% |
| 10 MI FINAL | 4 | < 0.1% |
| Other values (502) | 537 | 0.3% |
| (Missing) | 213190 |
Length
| Value | Count | Frequency (%) |
| mi | 249 | 12.4% |
| nm | 80 | 4.0% |
| of | 67 | 3.4% |
| 10 | 66 | 3.3% |
| 5 | 59 | 2.9% |
| n | 51 | 2.5% |
| e | 49 | 2.5% |
| w | 48 | 2.4% |
| miles | 46 | 2.3% |
| 15 | 46 | 2.3% |
| Other values (373) | 1239 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 2460 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -91.66612381 |
| Minimum | -177.381 |
|---|---|
| Maximum | 178.559228 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 211819 |
| Negative (%) | 99.1% |
| Memory size | 1.6 MiB |
Quantile statistics
| Minimum | -177.381 |
|---|---|
| 5-th percentile | -122.37484 |
| Q1 | -100.49631 |
| median | -87.90446 |
| Q3 | -80.29056 |
| 95-th percentile | -72.8871 |
| Maximum | 178.559228 |
| Range | 355.940228 |
| Interquartile range (IQR) | 20.20575 |
Descriptive statistics
| Standard deviation | 25.16118536 |
|---|---|
| Coefficient of variation (CV) | -0.274487284 |
| Kurtosis | 28.86807481 |
| Mean | -91.66612381 |
| Median Absolute Deviation (MAD) | 9.13274 |
| Skewness | 3.039541983 |
| Sum | -19595925.62 |
| Variance | 633.0852489 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -104.667 | 7786 | 3.6% |
| -97.0372 | 6752 | 3.2% |
| -87.90446 | 5371 | 2.5% |
| -73.77893 | 4418 | 2.1% |
| -89.97667 | 4152 | 1.9% |
| -121.59077 | 3272 | 1.5% |
| -111.97777 | 3223 | 1.5% |
| -81.31603 | 3008 | 1.4% |
| -83.34884 | 2962 | 1.4% |
| -73.87261 | 2847 | 1.3% |
| Other values (2450) | 169984 |
| Value | Count | Frequency (%) |
| -177.381 | 74 | |
| -176.6460306 | 2 | < 0.1% |
| -171.7327778 | 1 | < 0.1% |
| -170.71053 | 45 | |
| -170.2225556 | 1 | < 0.1% |
| -169.6637361 | 2 | < 0.1% |
| -169.5345 | 5 | < 0.1% |
| -168.9530556 | 1 | < 0.1% |
| -166.5435 | 26 | < 0.1% |
| -165.6041083 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 178.559228 | 1 | < 0.1% |
| 177.443378 | 1 | < 0.1% |
| 174.791667 | 5 | < 0.1% |
| 174.11333 | 2 | < 0.1% |
| 171.27203 | 9 | |
| 167.4333 | 2 | < 0.1% |
| 166.63666 | 1 | < 0.1% |
| 158.208989 | 21 | |
| 153.11833 | 1 | < 0.1% |
| 151.177222 | 9 |
| Distinct | 585 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.2 MiB |
| UNK | |
|---|---|
| BUS | |
| SWA | |
| AAL | |
| UAL | |
| Other values (580) |
Length
| Max length | 5 |
|---|---|
| Median length | 3 |
| Mean length | 3.023688457 |
| Min length | 3 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 98 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | PVT |
|---|---|
| 2nd row | TWA |
| 3rd row | UAL |
| 4th row | PVT |
| 5th row | AAL |
Common Values
| Value | Count | Frequency (%) |
| UNK | 64856 | |
| BUS | 17670 | 8.3% |
| SWA | 17345 | 8.1% |
| AAL | 14069 | 6.6% |
| UAL | 10532 | 4.9% |
| DAL | 8865 | 4.1% |
| FDX | 8011 | 3.7% |
| SKW | 4731 | 2.2% |
| UPS | 4527 | 2.1% |
| USA | 3775 | 1.8% |
| Other values (575) | 59394 |
Length
| Value | Count | Frequency (%) |
| unk | 64856 | |
| bus | 17670 | 8.3% |
| swa | 17345 | 8.1% |
| aal | 14069 | 6.6% |
| ual | 10532 | 4.9% |
| dal | 8865 | 4.1% |
| fdx | 8011 | 3.7% |
| skw | 4731 | 2.2% |
| ups | 4527 | 2.1% |
| usa | 3775 | 1.8% |
| Other values (572) | 59394 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 11 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 65371 |
| Missing (%) | 30.6% |
| Memory size | 11.3 MiB |
| Approach | |
|---|---|
| Landing Roll | |
| Take-off Run | |
| Climb | |
| Descent | 1974 |
| Other values (6) | 4005 |
Length
| Max length | 12 |
|---|---|
| Median length | 8 |
| Mean length | 8.927609768 |
| Min length | 4 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Approach |
|---|---|
| 2nd row | Landing Roll |
| 3rd row | Landing Roll |
| 4th row | Approach |
| 5th row | Approach |
Common Values
| Value | Count | Frequency (%) |
| Approach | 64585 | |
| Landing Roll | 27459 | |
| Take-off Run | 26340 | |
| Climb | 24041 | 11.2% |
| Descent | 1974 | 0.9% |
| Departure | 1957 | 0.9% |
| Local | 802 | 0.4% |
| Arrival | 601 | 0.3% |
| Taxi | 554 | 0.3% |
| Parked | 81 | < 0.1% |
| (Missing) | 65371 |
Length
| Value | Count | Frequency (%) |
| approach | 64585 | |
| landing | 27459 | |
| roll | 27459 | |
| take-off | 26340 | |
| run | 26340 | |
| climb | 24041 | 11.9% |
| descent | 1974 | 1.0% |
| departure | 1957 | 1.0% |
| local | 802 | 0.4% |
| arrival | 601 | 0.3% |
| Other values (3) | 645 | 0.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 11 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 103893 |
| Missing (%) | 48.6% |
| Memory size | 9.6 MiB |
| None | |
|---|---|
| Rain | 6700 |
| Fog | 2279 |
| Snow | 396 |
| Fog, Rain | 269 |
| Other values (6) | 57 |
Length
| Max length | 15 |
|---|---|
| Median length | 4 |
| Mean length | 3.994667006 |
| Min length | 3 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | None |
|---|---|
| 2nd row | None |
| 3rd row | None |
| 4th row | None |
| 5th row | None |
Common Values
| Value | Count | Frequency (%) |
| None | 100181 | |
| Rain | 6700 | 3.1% |
| Fog | 2279 | 1.1% |
| Snow | 396 | 0.2% |
| Fog, Rain | 269 | 0.1% |
| Rain, Snow | 20 | < 0.1% |
| Fog, Snow | 14 | < 0.1% |
| None, Snow | 10 | < 0.1% |
| Fog, Rain, Snow | 5 | < 0.1% |
| Fog, None | 5 | < 0.1% |
| (Missing) | 103893 |
Length
| Value | Count | Frequency (%) |
| none | 100199 | |
| rain | 6997 | 6.3% |
| fog | 2572 | 2.3% |
| snow | 445 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 808 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 30089 |
| Missing (%) | 14.1% |
| Memory size | 11.4 MiB |
| 17R | 3515 |
|---|---|
| 27 | 3422 |
| 22L | 3215 |
| 23 | 3178 |
| 16R | 3166 |
| Other values (803) |
Length
| Max length | 31 |
|---|---|
| Median length | 3 |
| Mean length | 2.626248054 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 396 ? |
|---|---|
| Unique (%) | 0.2% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 22R |
| 3rd row | 35 |
| 4th row | 26L |
| 5th row | 24R |
Common Values
| Value | Count | Frequency (%) |
| 17R | 3515 | 1.6% |
| 27 | 3422 | 1.6% |
| 22L | 3215 | 1.5% |
| 23 | 3178 | 1.5% |
| 16R | 3166 | 1.5% |
| 22 | 3165 | 1.5% |
| 17L | 3117 | 1.5% |
| 31 | 3088 | 1.4% |
| 4R | 3051 | 1.4% |
| 24 | 2854 | 1.3% |
| Other values (798) | 151915 | |
| (Missing) | 30089 | 14.1% |
Length
| Value | Count | Frequency (%) |
| 17r | 3529 | 1.9% |
| 27 | 3422 | 1.9% |
| 22l | 3227 | 1.7% |
| 23 | 3178 | 1.7% |
| 16r | 3176 | 1.7% |
| 22 | 3166 | 1.7% |
| 17l | 3124 | 1.7% |
| 31 | 3090 | 1.7% |
| 4r | 3057 | 1.7% |
| 24 | 2856 | 1.5% |
| Other values (608) | 152773 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 99952 |
| Missing (%) | 46.8% |
| Memory size | 10.2 MiB |
| No Cloud | |
|---|---|
| Some Cloud | |
| Overcast |
Length
| Max length | 10 |
|---|---|
| Median length | 8 |
| Mean length | 8.691494689 |
| Min length | 8 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | No Cloud |
|---|---|
| 2nd row | No Cloud |
| 3rd row | No Cloud |
| 4th row | No Cloud |
| 5th row | No Cloud |
Common Values
| Value | Count | Frequency (%) |
| No Cloud | 54187 | |
| Some Cloud | 39354 | 18.4% |
| Overcast | 20282 | 9.5% |
| (Missing) | 99952 |
Length
Pie chart
| Value | Count | Frequency (%) |
| cloud | 93541 | |
| no | 54187 | |
| some | 39354 | |
| overcast | 20282 | 9.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 277 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 133030 |
| Missing (%) | 62.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 143.0360518 |
| Minimum | 0 |
|---|---|
| Maximum | 400 |
| Zeros | 15 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 75 |
| Q1 | 120 |
| median | 140 |
| Q3 | 160 |
| 95-th percentile | 250 |
| Maximum | 400 |
| Range | 400 |
| Interquartile range (IQR) | 40 |
Descriptive statistics
| Standard deviation | 46.09679136 |
|---|---|
| Coefficient of variation (CV) | 0.3222739358 |
| Kurtosis | 0.8132594206 |
| Mean | 143.0360518 |
| Median Absolute Deviation (MAD) | 20 |
| Skewness | 0.6118044344 |
| Sum | 11549446 |
| Variance | 2124.914174 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 140 | 9082 | 4.2% |
| 130 | 6432 | 3.0% |
| 120 | 5717 | 2.7% |
| 150 | 5483 | 2.6% |
| 100 | 5009 | 2.3% |
| 135 | 4115 | 1.9% |
| 250 | 3601 | 1.7% |
| 160 | 3421 | 1.6% |
| 180 | 2998 | 1.4% |
| 110 | 2636 | 1.2% |
| Other values (267) | 32251 | 15.1% |
| (Missing) | 133030 |
| Value | Count | Frequency (%) |
| 0 | 15 | < 0.1% |
| 1 | 1 | < 0.1% |
| 2 | 4 | < 0.1% |
| 3 | 5 | < 0.1% |
| 4 | 4 | < 0.1% |
| 5 | 38 | |
| 6 | 1 | < 0.1% |
| 7 | 2 | < 0.1% |
| 8 | 3 | < 0.1% |
| 9 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 400 | 2 | < 0.1% |
| 380 | 1 | < 0.1% |
| 374 | 1 | < 0.1% |
| 365 | 1 | < 0.1% |
| 363 | 1 | < 0.1% |
| 355 | 2 | < 0.1% |
| 354 | 1 | < 0.1% |
| 350 | 8 | |
| 340 | 5 | |
| 335 | 1 | < 0.1% |
| Distinct | 63 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.0 MiB |
| TX | |
|---|---|
| CA | |
| FL | |
| NY | 11751 |
| IL | 10231 |
| Other values (58) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | IN |
|---|---|
| 2nd row | LA |
| 3rd row | IL |
| 4th row | NH |
| 5th row | TX |
Common Values
| Value | Count | Frequency (%) |
| TX | 20780 | 9.7% |
| CA | 17846 | 8.3% |
| FL | 16600 | 7.8% |
| NY | 11751 | 5.5% |
| IL | 10231 | 4.8% |
| CO | 9952 | 4.7% |
| PA | 7280 | 3.4% |
| TN | 7062 | 3.3% |
| OH | 6983 | 3.3% |
| NJ | 6493 | 3.0% |
| Other values (53) | 98797 |
Length
| Value | Count | Frequency (%) |
| tx | 20780 | 9.7% |
| ca | 17846 | 8.3% |
| fl | 16600 | 7.8% |
| ny | 11751 | 5.5% |
| il | 10231 | 4.8% |
| co | 9952 | 4.7% |
| pa | 7280 | 3.4% |
| tn | 7062 | 3.3% |
| oh | 6983 | 3.3% |
| nj | 6493 | 3.0% |
| Other values (53) | 98797 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 1468 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 98272 |
| Missing (%) | 46.0% |
| Memory size | 9.8 MiB |
| 09:00 | 1084 |
|---|---|
| 08:00 | 1042 |
| 10:00 | 1005 |
| 11:00 | 847 |
| 08:30 | 836 |
| Other values (1463) |
Length
| Max length | 6 |
|---|---|
| Median length | 5 |
| Mean length | 4.999930738 |
| Min length | 4 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 23 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 19:05 |
|---|---|
| 2nd row | 08:08 |
| 3rd row | 08:10 |
| 4th row | 18:00 |
| 5th row | 20:25 |
Common Values
| Value | Count | Frequency (%) |
| 09:00 | 1084 | 0.5% |
| 08:00 | 1042 | 0.5% |
| 10:00 | 1005 | 0.5% |
| 11:00 | 847 | 0.4% |
| 08:30 | 836 | 0.4% |
| 22:00 | 830 | 0.4% |
| 09:30 | 821 | 0.4% |
| 21:00 | 811 | 0.4% |
| 07:00 | 807 | 0.4% |
| 23:00 | 784 | 0.4% |
| Other values (1458) | 106636 | |
| (Missing) | 98272 |
Length
| Value | Count | Frequency (%) |
| 09:00 | 1084 | 0.9% |
| 08:00 | 1042 | 0.9% |
| 10:00 | 1005 | 0.9% |
| 11:00 | 847 | 0.7% |
| 08:30 | 836 | 0.7% |
| 22:00 | 830 | 0.7% |
| 09:30 | 821 | 0.7% |
| 21:00 | 811 | 0.7% |
| 07:00 | 807 | 0.7% |
| 23:00 | 784 | 0.7% |
| Other values (1453) | 106636 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 78080 |
| Missing (%) | 36.5% |
| Memory size | 10.2 MiB |
| Day | |
|---|---|
| Night | |
| Dusk | 6250 |
| Dawn | 5048 |
Length
| Max length | 5 |
|---|---|
| Median length | 3 |
| Mean length | 3.67096061 |
| Min length | 3 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Night |
|---|---|
| 2nd row | Day |
| 3rd row | Day |
| 4th row | Night |
| 5th row | Night |
Common Values
| Value | Count | Frequency (%) |
| Day | 84523 | |
| Night | 39874 | |
| Dusk | 6250 | 2.9% |
| Dawn | 5048 | 2.4% |
| (Missing) | 78080 |
Length
Pie chart
| Value | Count | Frequency (%) |
| day | 84523 | |
| night | 39874 | |
| dusk | 6250 | 4.6% |
| dawn | 5048 | 3.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.6 MiB |
| Unknown | |
|---|---|
| No | |
| Yes |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 4.995209917 |
| Min length | 2 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | No |
|---|---|
| 2nd row | Unknown |
| 3rd row | Unknown |
| 4th row | No |
| 5th row | No |
Common Values
| Value | Count | Frequency (%) |
| Unknown | 119844 | |
| No | 52850 | |
| Yes | 41081 | 19.2% |
Length
Pie chart
| Value | Count | Frequency (%) |
| unknown | 119844 | |
| no | 52850 | |
| yes | 41081 | 19.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 65249 |
| Missing (%) | 30.5% |
| Memory size | 10.2 MiB |
| A | |
|---|---|
| B | 792 |
| J | 4 |
| C | 4 |
| Y | 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | A |
|---|---|
| 2nd row | A |
| 3rd row | A |
| 4th row | A |
| 5th row | A |
Common Values
| Value | Count | Frequency (%) |
| A | 147725 | |
| B | 792 | 0.4% |
| J | 4 | < 0.1% |
| C | 4 | < 0.1% |
| Y | 1 | < 0.1% |
| (Missing) | 65249 |
Length
Pie chart
| Value | Count | Frequency (%) |
| a | 147725 | |
| b | 792 | 0.5% |
| j | 4 | < 0.1% |
| c | 4 | < 0.1% |
| y | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 65597 |
| Missing (%) | 30.7% |
| Memory size | 11.0 MiB |
| 4.0 | |
|---|---|
| 3.0 | |
| 1.0 | 9439 |
| 2.0 | 8604 |
| 5.0 | 1647 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1.0 |
|---|---|
| 2nd row | 4.0 |
| 3rd row | 4.0 |
| 4th row | 1.0 |
| 5th row | 4.0 |
Common Values
| Value | Count | Frequency (%) |
| 4.0 | 100564 | |
| 3.0 | 27924 | 13.1% |
| 1.0 | 9439 | 4.4% |
| 2.0 | 8604 | 4.0% |
| 5.0 | 1647 | 0.8% |
| (Missing) | 65597 |
Length
Pie chart
| Value | Count | Frequency (%) |
| 4.0 | 100564 | |
| 3.0 | 27924 | 18.8% |
| 1.0 | 9439 | 6.4% |
| 2.0 | 8604 | 5.8% |
| 5.0 | 1647 | 1.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 208.9 KiB |
| False | |
|---|---|
| True | 14300 |
| Value | Count | Frequency (%) |
| False | 199475 | |
| True | 14300 | 6.7% |
| Distinct | 47 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.0783049 |
| Minimum | 0.03 |
|---|---|
| Maximum | 9.17 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.6 MiB |
Quantile statistics
| Minimum | 0.03 |
|---|---|
| 5-th percentile | 0.72 |
| Q1 | 2.58 |
| median | 3.29 |
| Q3 | 4.54 |
| 95-th percentile | 9.17 |
| Maximum | 9.17 |
| Range | 9.14 |
| Interquartile range (IQR) | 1.96 |
Descriptive statistics
| Standard deviation | 2.422975187 |
|---|---|
| Coefficient of variation (CV) | 0.5941133012 |
| Kurtosis | -0.3346380145 |
| Mean | 4.0783049 |
| Median Absolute Deviation (MAD) | 1.12 |
| Skewness | 0.7533522629 |
| Sum | 871839.63 |
| Variance | 5.870808759 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 9.17 | 19177 | 9.0% |
| 7.28 | 12796 | 6.0% |
| 4.32 | 12208 | 5.7% |
| 4.54 | 11372 | 5.3% |
| 7.58 | 10491 | 4.9% |
| 2.58 | 10415 | 4.9% |
| 3.99 | 10079 | 4.7% |
| 3.51 | 9776 | 4.6% |
| 6.22 | 9682 | 4.5% |
| 2.95 | 9586 | 4.5% |
| Other values (37) | 98193 |
| Value | Count | Frequency (%) |
| 0.03 | 234 | |
| 0.04 | 286 | |
| 0.05 | 188 | 0.1% |
| 0.08 | 106 | < 0.1% |
| 0.09 | 110 | 0.1% |
| 0.11 | 355 | |
| 0.12 | 124 | 0.1% |
| 0.13 | 185 | 0.1% |
| 0.17 | 153 | 0.1% |
| 0.18 | 507 |
| Value | Count | Frequency (%) |
| 9.17 | 19177 | |
| 7.58 | 10491 | |
| 7.28 | 12796 | |
| 6.22 | 9682 | |
| 4.54 | 11372 | |
| 4.32 | 12208 | |
| 3.99 | 10079 | |
| 3.97 | 8535 | |
| 3.51 | 9776 | |
| 3.29 | 6162 | 2.9% |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| df_index | AIRPORT_ID | DISTANCE | ENROUTE_STATE | FAAREGION | HEIGHT | INCIDENT_MONTH | INCIDENT_YEAR | LATITUDE | LOCATION | LONGITUDE | OPID | PHASE_OF_FLIGHT | PRECIPITATION | RUNWAY | SKY | SPEED | STATE | TIME | TIME_OF_DAY | WARNED | AC_CLASS | AC_MASS | INDICATED_DAMAGE | c_score | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | KMIE | NaN | NaN | AGL | 200.0 | 10 | 1990 | 40.24235 | NaN | -85.39586 | PVT | Approach | None | NaN | No Cloud | 70.0 | IN | NaN | Night | No | A | 1.0 | False | 2.95 |
| 1 | 1 | KMSY | 0.0 | NaN | ASW | 0.0 | 8 | 1993 | 29.99339 | NaN | -90.25803 | TWA | Landing Roll | NaN | 1 | NaN | NaN | LA | NaN | Day | Unknown | A | 4.0 | False | 2.08 |
| 2 | 2 | KORD | 0.0 | NaN | AGL | 0.0 | 8 | 1996 | 41.97960 | NaN | -87.90446 | UAL | Landing Roll | NaN | 22R | NaN | NaN | IL | NaN | NaN | Unknown | A | 4.0 | False | 4.54 |
| 3 | 3 | KMHT | 8.0 | NaN | ANE | 1800.0 | 9 | 1993 | 42.93452 | NaN | -71.43706 | PVT | Approach | None | 35 | No Cloud | 150.0 | NH | NaN | Day | No | A | 1.0 | True | 3.09 |
| 4 | 4 | KELP | NaN | NaN | ASW | 200.0 | 3 | 1991 | 31.80667 | NaN | -106.37781 | AAL | Approach | None | 26L | No Cloud | 135.0 | TX | NaN | Night | No | A | 4.0 | False | 0.72 |
| 5 | 5 | KPDX | NaN | NaN | ANM | 300.0 | 10 | 1990 | 45.58872 | NaN | -122.59750 | AAL | Approach | None | NaN | No Cloud | 140.0 | OR | NaN | Night | No | A | 4.0 | False | 3.29 |
| 6 | 7 | KLAX | 9.0 | NaN | AWP | 4000.0 | 4 | 1995 | 33.94254 | NaN | -118.40807 | UAL | Approach | NaN | 24R | NaN | NaN | CA | NaN | NaN | Unknown | A | 4.0 | False | 3.97 |
| 7 | 8 | KSAT | 0.0 | NaN | ASW | 0.0 | 8 | 1991 | 29.53369 | NaN | -98.46978 | SWA | Landing Roll | None | NaN | No Cloud | 120.0 | TX | NaN | Day | No | A | 4.0 | False | 3.51 |
| 8 | 9 | KSAT | NaN | NaN | ASW | 1500.0 | 4 | 1991 | 29.53369 | NaN | -98.46978 | AAL | Approach | None | NaN | Overcast | 170.0 | TX | NaN | Night | No | A | 4.0 | False | 3.51 |
| 9 | 10 | KBUR | NaN | NaN | AWP | 800.0 | 5 | 1990 | 34.20062 | NaN | -118.35850 | 1AWE | Approach | None | NaN | No Cloud | 120.0 | CA | NaN | Day | Yes | A | 4.0 | False | 3.97 |
Last rows
| df_index | AIRPORT_ID | DISTANCE | ENROUTE_STATE | FAAREGION | HEIGHT | INCIDENT_MONTH | INCIDENT_YEAR | LATITUDE | LOCATION | LONGITUDE | OPID | PHASE_OF_FLIGHT | PRECIPITATION | RUNWAY | SKY | SPEED | STATE | TIME | TIME_OF_DAY | WARNED | AC_CLASS | AC_MASS | INDICATED_DAMAGE | c_score | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 213765 | 255417 | W91 | 0.0 | NaN | AEA | 0.0 | 12 | 2009 | 37.104500 | NaN | -79.588700 | PVT | Landing Roll | NaN | NaN | NaN | NaN | VA | NaN | NaN | Unknown | A | 1.0 | True | 3.25 |
| 213766 | 255421 | KCDW | 0.0 | NaN | AEA | 0.0 | 3 | 2012 | 40.875220 | NaN | -74.281360 | PVT | Landing Roll | NaN | 4 | NaN | NaN | NJ | 23:25 | Night | Unknown | A | 1.0 | True | 9.17 |
| 213767 | 255754 | KJAX | 0.0 | NaN | ASO | NaN | 2 | 2020 | 30.494060 | NaN | -81.687860 | RPA | Climb | NaN | 8 | NaN | NaN | FL | NaN | NaN | Unknown | A | 4.0 | False | 1.14 |
| 213768 | 255755 | 57C | 0.0 | NaN | AGL | 0.0 | 1 | 2015 | 42.797167 | NaN | -88.372611 | BUS | Landing Roll | NaN | 26 | NaN | NaN | WI | 19:07 | Night | Unknown | A | 1.0 | True | 4.54 |
| 213769 | 255756 | KFWS | 1.0 | NaN | ASW | NaN | 6 | 2020 | 32.565228 | NaN | -97.308078 | PVT | Approach | NaN | 17R | NaN | NaN | TX | 12:13 | Day | Unknown | A | 1.0 | True | 4.32 |
| 213770 | 255758 | 50D | 0.0 | NaN | AGL | 0.0 | 6 | 2017 | 46.009080 | NaN | -88.274026 | PVT | Landing Roll | NaN | 30 | NaN | NaN | MI | 10:50 | Day | Unknown | A | 1.0 | True | 1.01 |
| 213771 | 255840 | KFSD | 0.0 | NaN | AGL | 100.0 | 2 | 2020 | 43.581350 | NaN | -96.741700 | LOF | Climb | None | 21 | Overcast | NaN | SD | 18:35 | Dusk | Unknown | A | 3.0 | True | 1.34 |
| 213772 | 255906 | KLAX | NaN | NaN | AWP | 100.0 | 8 | 2009 | 33.942540 | NaN | -118.408070 | SHQ | Climb | None | 25R | No Cloud | 190.0 | CA | 14:48 | Day | Unknown | A | 4.0 | True | 3.97 |
| 213773 | 255907 | KPMD | NaN | NaN | AWP | NaN | 12 | 2020 | 34.629390 | NaN | -118.084550 | BOE | Departure | NaN | NaN | NaN | NaN | CA | 12:20 | Day | Unknown | A | 4.0 | True | 3.97 |
| 213774 | 255908 | KMLI | NaN | NaN | AGL | 300.0 | 1 | 2020 | 41.448530 | NaN | -90.507540 | ENY | Climb | None | 27 | Overcast | 135.0 | IL | 09:59 | Day | Unknown | A | 3.0 | True | 2.15 |